CREATE TABLE [dbo].[PrefixRef]
(
[PrefixCode] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_PrefixRef_PrefixCode] DEFAULT (''),
[PrefixDesc] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_PrefixRef_PrefixDesc] DEFAULT (''),
[SyncPrefixCode] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_PrefixRef_SyncPrefixCode] DEFAULT (''),
[Gender] [nchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PrefixKey] [uniqueidentifier] NOT NULL CONSTRAINT [DF_PrefixRef_PrefixKey] DEFAULT (newid())
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[PrefixRef] ADD CONSTRAINT [PK_PrefixRef] PRIMARY KEY CLUSTERED ([PrefixCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PrefixRef] ADD CONSTRAINT [AX_PrefixRef_PrefixKey] UNIQUE NONCLUSTERED ([PrefixKey]) ON [PRIMARY]
GO